<%@ page import="java.util.List" %>
<%@ page import="sun.swing.BakedArrayList" %>
<%@ page import="org.apache.catalina.User" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %><%--
  Created by IntelliJ IDEA.
  User: ASUS
  Date: 2018/4/3
  Time: 15:56
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户列表</title>
</head>
<body>

<style type="text/css">
    table {
        border-collapse: collapse;
    }

    td {
        border: 1px solid #000000;
        padding: 10px;
    }
</style>
<h1>用户列表</h1>
<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
    </tr>
    <%
        class user {
            int id;
            String username;
            String password;
        }
        List<User> userList = new ArrayList<User>();

        Connection connection = null;
        Statement statement = null;
        ResultSet resultset = null;

        String sql = "select*from t_users";


    %>

    <tr>
        <td>1</td>
        <td>John</td>
        <td>123456</td>
    </tr>
</table>
<jsp:include page="footer.jsp">
    <jsp:param name="year" value="2016"/>
</jsp:include>
</body>
</html>
